MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Artist Role = 1992

View and edit SQL

Suggested facets: Object Name, Medium, Credit Line, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
219303 54.524.45 0 0 346821 Drawings and Prints 11 Book 97 A Progressive Course of Inventive Drawing, First Course           Publisher|Author|Lithographer 1992   Ticknor, Reed & Fields|William J. Whitaker|J. H. Bufford & Co. Boston, Massachusetts|American, 19th century|Boston, Massachusetts   Ticknor, Reed & Fields|Whitaker, William J.|Bufford, J. H., & Co. 22465 American|American|American 101 1800 |1800 |1835 1900 |1900 |1870 1853 1853 1853 Illustrations: lithography 28996 7 1/2 x 4 3/4 in. (19.1 x 12.1 cm) Harris Brisbane Dick Fund, 1954   Boston 8                   Books 442   Metropolitan Museum of Art, New York, NY 1
219981 54.524.69 0 0 347509 Drawings and Prints 11 Book 97 Childs' Drawing Book of Objects: Studies from Still Life, for Young Pupils, and Drawing Classes in Schools           Publisher|Author|Lithographer 1992   John W. Moore|George Childs|Wagner & McGuigan Philadelphia, Pennsylvania|British, active 1831–59|American, 1845–1863   Moore, John W.|Childs, George|Wagner & McGuigan 22964 American 1 1800 |1831 |1845 1900 |1859 |1863 1845 1845 1845 Illustrations: lithography 28996 7 3/4 x 10 3/4 in. (19.7 x 27.3 cm) Harris Brisbane Dick Fund, 1954   Philadelphia 1                   Books 442   Metropolitan Museum of Art, New York, NY 1
222603 52.519.189 0 0 350164 Drawings and Prints 11 Book ; Ornament and architecture 13811 Church Architecture: Plans Elevations and Views Of Twenty-One Churches And Two School-Houses           Publisher|Author|Lithographer 1992   Amos Jackson Bicknell & Co.|Frederick Clarke Withers|Julius Bien New York, NY|American (born England), Shepton Mallet, Somersetshire 1828–1901 Yonkers, New York|American (born Germany), Naumberg 1826–1909 United States   Bicknell, Amos Jackson, & Co.|Withers, Frederick Clarke|Bien, Julius 24783 American|American, born England 65 1860 |1828 |1826 1900 |1901 |1909 1873 1873 1873 Illustrations: photo-lithography 35025 18 11/16 × 13 11/16 × 1 3/16 in. (47.4 × 34.8 × 3 cm) Rogers Fund, 1952                       Books|Ornament & Architecture 665   Metropolitan Museum of Art, New York, NY 1
223181 52.593 0 0 350755 Drawings and Prints 11 Book ; Ornament and architecture 13811 Beautifying country homes. A handbook of landscape gardening, illustrated by plans of places already improved           Publisher|Author|Lithographer 1992   Orange Judd and Co.|Jacob Weidenmann|Herman Bencke New York, NY|American (born Switzerland), Winterthur 1829–1893|New York, NY   Judd, Orange, and Co.|Weidenmann, Jacob|Bencke, Herman 25255 American|American, born Switzerland|American 1718 1850 |1829 |1800 1950 |1893 |1900 1870 1870 1870 Illustrations: color lithography and wood engraving 34005 14 × 10 11/16 × 9/16 in. (35.5 × 27.2 × 1.5 cm) Gift of Miss M. Weidenman, 1952                       Books|Ornament & Architecture 665   Metropolitan Museum of Art, New York, NY 1
229597 53.545.3 0 0 357261 Drawings and Prints 11 Book ; Ornament and architecture 13811 Sloan's Constructive Architecture           Publisher|Author|Lithographer 1992   J. B. Lippincott Company|Samuel Sloan|Rosenthal Philadelphia|American, Beaver Dam, Pennsylvania 1815–1884 Raleigh, North Carolina|Philadelphia, Pennsylvania   Lippincott, J. B., Company|Sloan, Samuel|Rosenthal 29850 American|American 5 1800 |1815 |1840 1950 |1884 |1900 1859 1859 1859 Illustrations: lithography and color lithography 34026 11 13/16 × 9 7/16 × 1 3/16 in. (30 × 24 × 3 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1953                       Books|Ornament & Architecture 665   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 128.373ms · Data license: CC0 · Data source: metmuseum/openaccess